UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IvDNLeOW9HXEFHbwhGXUIrOtNr38+tZBYC/JG0BflOE=' 
WHERE 
  key_id = 'e46e6d2689b3dd5e77504a1a2f56e7ca075381e1fade936d909b25985b4c9a8e' 
  AND (
    token = 'IvDNLeOW9HXEFHbwhGXUIrOtNr38+tZBYC/JG0BflOE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021