UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hlCxX7wlKe1WYHR0N9jVemIi1p8FXrL5S43upLKTyrQ='
WHERE
key_id = '7a4527bad8bbacb335fc87edd435424c92a1d67c5b650c1a4cda5ea343e4d520'
AND (
token = 'hlCxX7wlKe1WYHR0N9jVemIi1p8FXrL5S43upLKTyrQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)