UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'moliQ9UfcrF/YQaPnHkkOJpgKGOTpx22PAar8zRup/M='
WHERE
key_id = 'b0e26be8b10f90784730cdd9cf0d0bb61c346da8d4549837092eb058c2415f07'
AND (
token = 'moliQ9UfcrF/YQaPnHkkOJpgKGOTpx22PAar8zRup/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)