UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N1oKKecg4wED7siF++dQhIrMAHpOQ1Our+AIYnI9m6o='
WHERE
key_id = '9b93f04845c9bdb8881ec7dce04f86f150bb9dd4d51c84ecf04b81c2e8b08708'
AND (
token = 'N1oKKecg4wED7siF++dQhIrMAHpOQ1Our+AIYnI9m6o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)