UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yINVOTodcyeD9nStO5vHczf1HTw5e1BW4TO0OUUKrIo=' 
WHERE 
  key_id = 'd51db01cc5331513e5008c8e849fc9c9a1fa2fb2e3fca413005e3d848f3923c2' 
  AND (
    token = 'yINVOTodcyeD9nStO5vHczf1HTw5e1BW4TO0OUUKrIo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038