UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gjN9z/3k9pmvmAfARMvn7+BtjqAHBn99L3lqxiQWyY='
WHERE
key_id = 'f9f5a0d1344483469e9e6f3946608dd6eb046b9b88bb60266ffca8ed98d037ce'
AND (
token = '6gjN9z/3k9pmvmAfARMvn7+BtjqAHBn99L3lqxiQWyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)