UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ncYTeZ434Hz3HcdtbiTO7Id/iUKSTafAJqzN7hslyY4='
WHERE
key_id = 'b76e7601d2084336a477c83c89046528800e8b452feb6af01655663ea45ac260'
AND (
token = 'ncYTeZ434Hz3HcdtbiTO7Id/iUKSTafAJqzN7hslyY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)