UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BJthihjSY9rKwKD21IgqjhJZuv/TZM7gRg4zu3nGGnw=' 
WHERE 
  key_id = 'c7ecbce27c70388360f6b94a3b4fab4918e1f9f0feb43478275fe64afd7255e5' 
  AND (
    token = 'BJthihjSY9rKwKD21IgqjhJZuv/TZM7gRg4zu3nGGnw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022