UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qaGqMbBDpaHJhWZ4cE/oLKexHBnRt7c9M0e3hhX4gXM='
WHERE
key_id = 'a8ee64110f1ffdc831276beee5dfc2392af50f37c4a1758c9e4afe7fddeca36f'
AND (
token = 'qaGqMbBDpaHJhWZ4cE/oLKexHBnRt7c9M0e3hhX4gXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)