UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1j74X/b9njEhpIUi8vjSHZSoh4NVNevKdSnly0kvdvM='
WHERE
key_id = '2fd7afc665d32ad33f3faaaf989ee16fe167b14d5d563242ff47290343331b5e'
AND (
token = '1j74X/b9njEhpIUi8vjSHZSoh4NVNevKdSnly0kvdvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)