UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kTAi9vcKmGBVigDH+QI7T0HybFnGWmy/s2DeofFFfoU='
WHERE
key_id = '4dbe9ab30af35e2dc5bdd3c0325780ed23688aaba86e50bd14a4ea773eda1066'
AND (
token = 'kTAi9vcKmGBVigDH+QI7T0HybFnGWmy/s2DeofFFfoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)