UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'K1wjAyYad9LBeofwSy8UKgPxp7J7BGKOaeY9roqoBCI=' 
WHERE 
  key_id = '8ef05088286bd590d0839e7ea93c58490a8fd3e4b77b78e62951d113814f4d62' 
  AND (
    token = 'K1wjAyYad9LBeofwSy8UKgPxp7J7BGKOaeY9roqoBCI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023