UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6FVBZWSwB7NftUZqQy7WcckXb1XR0DvtNwXajTOCY0w='
WHERE
key_id = '8686b38c8a022a638cb90658826b2022fd99ebea1daf97c731c25b5647ab0207'
AND (
token = '6FVBZWSwB7NftUZqQy7WcckXb1XR0DvtNwXajTOCY0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)