UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kYNs/1GWhFxWiidWKu1wKebirzee/GMS7fI3A5sOo8Y='
WHERE
key_id = 'e73602e9336099cbfff11228d6aef34914f33bb5ad78637c8abb3f51c468ad4a'
AND (
token = 'kYNs/1GWhFxWiidWKu1wKebirzee/GMS7fI3A5sOo8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)