UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vBYHTa7yrsUNmbv0xB/9pl9ilNes1WN7g+jIoEtmhYM='
WHERE
key_id = 'e453412de5d7729a37ba50684ae1cf3df329006243c33d35fb837f7a66346ec7'
AND (
token = 'vBYHTa7yrsUNmbv0xB/9pl9ilNes1WN7g+jIoEtmhYM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)