UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'htvb9fpbo7jPHdssqv54EgqcRgp2tcGEPEUK+94kAXY=' 
WHERE 
  key_id = '314987d8ccfcbf8177bd030670f1b1ab91da1aa05911b429c15aa06b5d2bf905' 
  AND (
    token = 'htvb9fpbo7jPHdssqv54EgqcRgp2tcGEPEUK+94kAXY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022