UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'S/w0pNyvA/67pzhwI92ELUTKnoZwWlf92DKV3W8Fsd0=' 
WHERE 
  key_id = '5c9103b4cd50c94f97f68f8d7bd52a4daf77e9832c72a826e582b784d5291190' 
  AND (
    token = 'S/w0pNyvA/67pzhwI92ELUTKnoZwWlf92DKV3W8Fsd0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024