UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tcRT78MyzW+VOo7nwk/kYgZI6dP9NNj3xmhRkZjsMnI=' 
WHERE 
  key_id = '2660b054df066b9f177a66103094fa8467c5bd3acf7b47d073c42da7803b0af8' 
  AND (
    token = 'tcRT78MyzW+VOo7nwk/kYgZI6dP9NNj3xmhRkZjsMnI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045