UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pVe1kEvajnd5XV0HUvtPwW1nSHobIxQXvBuAv7ox35o=' 
WHERE 
  key_id = '0f1f89d3245b12e84c8f756f79c35d42d984ddc3e419e900e1b9008c24a77b5f' 
  AND (
    token = 'pVe1kEvajnd5XV0HUvtPwW1nSHobIxQXvBuAv7ox35o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031