UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jGaJK8YWMob6fcLJYbp6k1Ski5vHU/Y9IZCK1w0WfyU='
WHERE
key_id = 'b492a1fe8a5b4f294eaf827936e5ff61b087a5a9954493f3146f9947f9dea583'
AND (
token = 'jGaJK8YWMob6fcLJYbp6k1Ski5vHU/Y9IZCK1w0WfyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)