UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KXK0fE8NLuEWNrm0Vx7YsXVnrUyGtb7haW6vtWQAHAk='
WHERE
key_id = '0a7dee5d82003e39a2a9a24a2c117faa85e8469d295ee4c14619ca049b32f27d'
AND (
token = 'KXK0fE8NLuEWNrm0Vx7YsXVnrUyGtb7haW6vtWQAHAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)