UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bgMgeUJWJojuOhyzoCCIYPrfQ6qt3pAjXaX4O0GEZDo='
WHERE
key_id = '29b7e1a9e512f71cabfa52c4d681a8e58d8878bc220430568576921de5991b9e'
AND (
token = 'bgMgeUJWJojuOhyzoCCIYPrfQ6qt3pAjXaX4O0GEZDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)