UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NB9qdbeTmusuRcF4qy9UMGe/HWLKpIW27TZUQ0CJIxk='
WHERE
key_id = '9e03ffbd2a8fab57e930fc5d24504266ce8bf9cae2ef99d375aa1140e9e3a5fb'
AND (
token = 'NB9qdbeTmusuRcF4qy9UMGe/HWLKpIW27TZUQ0CJIxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)