UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HpqzzWCjun10jeh1pZ8S+ztgVvJOZwVhV5JStBWtYsM='
WHERE
key_id = '4841b1c378360408405a85dd4f1cfed50009a3b4c02f4df801f109607a760e12'
AND (
token = 'HpqzzWCjun10jeh1pZ8S+ztgVvJOZwVhV5JStBWtYsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)