UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hhM4NdZogv8F7811aNXZMJIrBcBKAlD4J4gFd3ZXAUc='
WHERE
key_id = '842e1f62cfee90524d27cab21df87ce30f631c59d6bd92008dc44db4e377bd2e'
AND (
token = 'hhM4NdZogv8F7811aNXZMJIrBcBKAlD4J4gFd3ZXAUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)