UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wr31R6sR6ABIwsySUGy7XUHceu7QWqlSomhaFnMYdMQ='
WHERE
key_id = '2dc9b9bf0315ca15a12f43ace309f7e3abf83414e0fa0bffe11365c778bc8542'
AND (
token = 'wr31R6sR6ABIwsySUGy7XUHceu7QWqlSomhaFnMYdMQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)