UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TxTfG79Uya1JhBIdO23Z0GyqaKQgSymVo/KwLe9vVIo='
WHERE
key_id = '174605bba56be5a31ec0684c02b2667ea268f5a63c3ae06a8a11b5d01f063277'
AND (
token = 'TxTfG79Uya1JhBIdO23Z0GyqaKQgSymVo/KwLe9vVIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)