UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'navDl7HKFbq3Obj4LNNgZ9MPVIjQW6rwRCAvpecTFIA='
WHERE
key_id = '66b30c9f1383aaba1a9f76b970d4e65d3fbf65032053a305195c6177df0a8e82'
AND (
token = 'navDl7HKFbq3Obj4LNNgZ9MPVIjQW6rwRCAvpecTFIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)