UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'h8b5b216ypNo+2S6oRFVt0lgaWMzBe/kd9tpP2XRo5Q=' 
WHERE 
  key_id = 'caee3727e9c2bf3aa3a7853a35a496a03bab02dca64b0841a7927caf37d6429a' 
  AND (
    token = 'h8b5b216ypNo+2S6oRFVt0lgaWMzBe/kd9tpP2XRo5Q=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042