UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gN+ZAhCpOXVkqn1b6MgnzRHjVE5H1EtlpZvXNDgd9jM='
WHERE
key_id = 'c14edb5c4b5cbd37bb876888228e5403322c1df249e42b1971ebcf80f8a2bc88'
AND (
token = 'gN+ZAhCpOXVkqn1b6MgnzRHjVE5H1EtlpZvXNDgd9jM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)