UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1cofj6et8VNTaKiw7V7bDI5W7TtauQHqQBw7PdY/YQo='
WHERE
key_id = '77088dfb5be1de7f1699aa9295e6101217de6a74fd05404b915cc1a2fe4b485f'
AND (
token = '1cofj6et8VNTaKiw7V7bDI5W7TtauQHqQBw7PdY/YQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)