UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 't3kOEOG6BDwdifIdmm+hm0X5KBT31fXtpfojHCrgHEA=' 
WHERE 
  key_id = 'cf1003299b4bb7b0944df53e93cd61e1dddc5eee53515f3d4b4a7c51cfad7d24' 
  AND (
    token = 't3kOEOG6BDwdifIdmm+hm0X5KBT31fXtpfojHCrgHEA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028