UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e9m6ym1fXU86YhP/fYpxCfYGvjPpMe53/Z61YWs9Y8g='
WHERE
key_id = 'c874f88e347cde72202eb9ab86d771b7cff924b760086a2097bd663b5b742692'
AND (
token = 'e9m6ym1fXU86YhP/fYpxCfYGvjPpMe53/Z61YWs9Y8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)