UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CF19HSG6iKVBo/MtPtNlksT5o0mkAUHzzajEEuLSTSQ='
WHERE
key_id = 'b6f386b2670e4eee33c6c7bc2df770e2f09308e81a4d357cd0795c977c8e3a71'
AND (
token = 'CF19HSG6iKVBo/MtPtNlksT5o0mkAUHzzajEEuLSTSQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)