UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QUa5UEYq0/X+xnNbOgvx0HSO3E23WZQmjOAF8P4xwTE='
WHERE
key_id = 'cfb0d13b46840db97857ce5a2e50f017304dcfc7dc5c575a8fe3632db4870835'
AND (
token = 'QUa5UEYq0/X+xnNbOgvx0HSO3E23WZQmjOAF8P4xwTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)