UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0j55IN5Oig703qxTrDTU53/oxTXlKlPFx/HKQkbHFjo=' 
WHERE 
  key_id = 'd9477acbd3d1036fd59cc5cc9d87b6afef14afa9e2b9ee4abf1d00b744b46a82' 
  AND (
    token = '0j55IN5Oig703qxTrDTU53/oxTXlKlPFx/HKQkbHFjo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025