UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '102HaocHeN7imkyDf0LiJZw/WUl7qv4QT97ReukT6/g='
WHERE
key_id = '9f5e6f691c336b90f82b8a1bc566a95970c572299761d0915a55723b4feed7aa'
AND (
token = '102HaocHeN7imkyDf0LiJZw/WUl7qv4QT97ReukT6/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)