UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cN0m/mJsrA6OKCkVu8ONo8S78AS57bmY3eA4HDh5ngY='
WHERE
key_id = '038a24cdc68ad860a331a83a39b23d874b2911b65b4699c274d24925b175b611'
AND (
token = 'cN0m/mJsrA6OKCkVu8ONo8S78AS57bmY3eA4HDh5ngY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)