UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lihsetDAopTqfMFJrK3ZMy2WYrKI5uVZgHMg64Vkho0='
WHERE
key_id = 'dc5f3522fd7a9314a433326adc387834a530d0d20c956d441144860e1b12db37'
AND (
token = 'lihsetDAopTqfMFJrK3ZMy2WYrKI5uVZgHMg64Vkho0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)