UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'APR6TYnegu5jLBwOAx2QwHQYRsks1W2o6y743SB3mnA=' 
WHERE 
  key_id = 'e906ab741ddd7bdfaa556a5faa8be8818d877ee8e8a0b602d3d93cc3573865ef' 
  AND (
    token = 'APR6TYnegu5jLBwOAx2QwHQYRsks1W2o6y743SB3mnA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024